<?php
  // sprites
  require_once dirname(__FILE__)."/../purin2/core/core.php";
  require_once dirname(__FILE__)."/../purin2/xtr/xtr.php";
  
  puXtrBegin('List of all sprites its gender and related equipment type');
  puXtrInputs();
  puXtrOutputs(
    'i_spri','integer','Serial',
    'j_eqty','integer','Equipment type',
    'v_race','string','Sprite race',
    'v_xml','string','Sprite xml file',
    'i_red','integer','Red multiplier',
    'i_green','integer','Green multiplier',
    'i_blue','integer','Blue multiplier'
  );
  puXtrRowsSql("select i_spri, j_eqty, v_race, v_xml, i_red, i_green, i_blue from spri, eqty where j_eqty=i_eqty",1);
  puXtrEnd(0,'Successfull');
?>